Stored Procedures [dbo].[BAEFieldDesignGetAllByNoSection]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
SQL Script
create procedure [dbo].[BAEFieldDesignGetAllByNoSection] as
SELECT *
FROM FieldDesign
WHERE
FieldDesign.FieldName
NOT IN
(SELECT FieldDesignSectionLookup.FieldName
FROM FieldDesignSectionLookup, FieldDesign
WHERE FieldDesignSectionLookup.TableName = FieldDesign.TableName)

GO
Uses